Overview

Dataset statistics

Number of variables38
Number of observations180508
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory271.2 MiB
Average record size in memory1.5 KiB

Variable types

CAT20
NUM13
BOOL2
DATE2
URL1

Reproduction

Analysis started2020-04-09 10:12:19.797816
Analysis finished2020-04-09 10:29:52.423695
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
Customer City has a high cardinality: 562 distinct values High cardinality
Customer Fname has a high cardinality: 775 distinct values High cardinality
Customer Lname has a high cardinality: 1109 distinct values High cardinality
Customer Street has a high cardinality: 7456 distinct values High cardinality
Order City has a high cardinality: 3597 distinct values High cardinality
Order Country has a high cardinality: 164 distinct values High cardinality
Order State has a high cardinality: 1089 distinct values High cardinality
Product Name has a high cardinality: 118 distinct values High cardinality
Longitude is highly correlated with Customer ZipcodeHigh Correlation
Customer Zipcode is highly correlated with LongitudeHigh Correlation
Sales is highly correlated with Sales per customerHigh Correlation
Sales per customer is highly correlated with SalesHigh Correlation
Customer State is highly correlated with Customer CountryHigh Correlation
Customer Country is highly correlated with Customer StateHigh Correlation
Department Name is highly correlated with Category NameHigh Correlation
Category Name is highly correlated with Department NameHigh Correlation
Order Region is highly correlated with MarketHigh Correlation
Market is highly correlated with Order RegionHigh Correlation
Order Status is highly correlated with TypeHigh Correlation
Type is highly correlated with Order StatusHigh Correlation
Shipping Mode is highly correlated with Days for shipment (scheduled)High Correlation
Days for shipment (scheduled) is highly correlated with Shipping ModeHigh Correlation
Days for shipping (real) has 5080 (2.8%) zeros Zeros
Order Item Discount has 10028 (5.6%) zeros Zeros
Order Item Discount Rate has 10028 (5.6%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

UNIFORM
UNIQUE
Distinct count180508
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean90259.03469
Minimum0
Maximum180518
Zeros1
Zeros (%)< 0.1%
Memory size1.4 MiB

Quantile statistics

Minimum0
5-th percentile9025.35
Q145128.75
median90259.5
Q3135389.25
95-th percentile171492.65
Maximum180518
Range180518
Interquartile range (IQR)90260.5

Descriptive statistics

Standard deviation52111.93206
Coefficient of variation (CV)0.5773597317
Kurtosis-1.200018572
Mean90259.03469
Median Absolute Deviation (MAD)45130.33252
Skewness-2.125550754e-05
Sum1.629247783e+10
Variance2715653463
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 180518.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 1 < 0.1%
 
67082 1 < 0.1%
 
132458 1 < 0.1%
 
138601 1 < 0.1%
 
136552 1 < 0.1%
 
159079 1 < 0.1%
 
157030 1 < 0.1%
 
163173 1 < 0.1%
 
161124 1 < 0.1%
 
150883 1 < 0.1%
 
Other values (180498) 180498 > 99.9%
 
ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 
ValueCountFrequency (%) 
180518 1 < 0.1%
 
180517 1 < 0.1%
 
180516 1 < 0.1%
 
180515 1 < 0.1%
 
180514 1 < 0.1%
 

Type
Categorical

HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
DEBIT
69290
TRANSFER
49880
PAYMENT
41722
CASH
19616
ValueCountFrequency (%) 
DEBIT 69290 38.4%
 
TRANSFER 49880 27.6%
 
PAYMENT 41722 23.1%
 
CASH 19616 10.9%
 

Length

Max length8
Mean length6.182595785
Min length4
ValueCountFrequency (%) 
Uppercase_Letter 15 100.0%
 
ValueCountFrequency (%) 
Latin 15 100.0%
 
ValueCountFrequency (%) 
ASCII 15 100.0%
 

Days for shipping (real)
Real number (ℝ≥0)

ZEROS
Distinct count7
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.497673233
Minimum0
Maximum6
Zeros5080
Zeros (%)2.8%
Memory size1.4 MiB

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q35
95-th percentile6
Maximum6
Range6
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.623742756
Coefficient of variation (CV)0.4642351208
Kurtosis-1.007927277
Mean3.497673233
Median Absolute Deviation (MAD)1.423789438
Skewness0.08475022722
Sum631358
Variance2.636540537
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 5.5 6. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2 56613 31.4%
 
3 28764 15.9%
 
6 28723 15.9%
 
4 28510 15.8%
 
5 28161 15.6%
 
0 5080 2.8%
 
1 4657 2.6%
 
ValueCountFrequency (%) 
0 5080 2.8%
 
1 4657 2.6%
 
2 56613 31.4%
 
3 28764 15.9%
 
4 28510 15.8%
 
ValueCountFrequency (%) 
6 28723 15.9%
 
5 28161 15.6%
 
4 28510 15.8%
 
3 28764 15.9%
 
2 56613 31.4%
 

Days for shipment (scheduled)
Categorical

HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
4
107745
2
35214
1
27812
0
 
9737
ValueCountFrequency (%) 
4 107745 59.7%
 
2 35214 19.5%
 
1 27812 15.4%
 
0 9737 5.4%
 

Length

Max length1
Mean length1
Min length1
ValueCountFrequency (%) 
Decimal_Number 4 100.0%
 
ValueCountFrequency (%) 
Common 4 100.0%
 
ValueCountFrequency (%) 
ASCII 4 100.0%
 

Benefit per order
Real number (ℝ)

Distinct count21996
Unique (%)12.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.97156317
Minimum-4274.97998
Maximum911.7999878
Zeros1177
Zeros (%)0.7%
Memory size1.4 MiB

Quantile statistics

Minimum-4274.97998
5-th percentile-139.2564964
Q17
median31.52000046
Q364.80000305
95-th percentile132.2899933
Maximum911.7999878
Range5186.779968
Interquartile range (IQR)57.80000305

Descriptive statistics

Standard deviation104.4338599
Coefficient of variation (CV)4.753137458
Kurtosis71.38010222
Mean21.97156317
Median Absolute Deviation (MAD)56.08786643
Skewness-4.742049787
Sum3966042.924
Variance10906.43109
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-4274.97998 -1355.61499 -1083.169983 -824.94000245 -674.98498535 ... 239.8199997 240.19000245 245.32499695 720.9499817 911.7999878 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1177 0.7%
 
143.9900055 199 0.1%
 
72 194 0.1%
 
46.79999924 188 0.1%
 
24 181 0.1%
 
18 175 0.1%
 
63.70000076 172 0.1%
 
62.40000153 168 0.1%
 
12 166 0.1%
 
14.39999962 166 0.1%
 
Other values (21986) 177722 98.5%
 
ValueCountFrequency (%) 
-4274.97998 1 < 0.1%
 
-3442.5 1 < 0.1%
 
-3366 1 < 0.1%
 
-3000 1 < 0.1%
 
-2592 1 < 0.1%
 
ValueCountFrequency (%) 
911.7999878 1 < 0.1%
 
864 1 < 0.1%
 
721.5999756 1 < 0.1%
 
720.2999878 1 < 0.1%
 
720 2 < 0.1%
 

Sales per customer
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count2927
Unique (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean183.1017509
Minimum7.489999771
Maximum1939.98999
Zeros0
Zeros (%)0.0%
Memory size1.4 MiB

Quantile statistics

Minimum7.489999771
5-th percentile41.5
Q1104.3799973
median163.9900055
Q3247.3999939
95-th percentile383.980011
Maximum1939.98999
Range1932.49999
Interquartile range (IQR)143.0199966

Descriptive statistics

Standard deviation120.0415784
Coefficient of variation (CV)0.6556003851
Kurtosis23.9241351
Mean183.1017509
Median Absolute Deviation (MAD)87.65783926
Skewness2.888772293
Sum33051330.86
Variance14409.98055
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 7.48999977 8.43000031 8.48000002 8.57499981 8.67499971 ... 1057.4949951 1215. 1492.494995 1549.994995 1939.98999 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
122.8399963 1264 0.7%
 
109.1900024 1247 0.7%
 
129.9900055 1243 0.7%
 
127.3899994 1243 0.7%
 
97.48999786 1243 0.7%
 
126.0899963 1243 0.7%
 
107.8899994 1243 0.7%
 
110.4899979 1243 0.7%
 
116.9899979 1243 0.7%
 
118.2900009 1243 0.7%
 
Other values (2917) 168053 93.1%
 
ValueCountFrequency (%) 
7.489999771 3 < 0.1%
 
7.989999771 3 < 0.1%
 
8.18999958 3 < 0.1%
 
8.289999962 3 < 0.1%
 
8.390000343 3 < 0.1%
 
ValueCountFrequency (%) 
1939.98999 1 < 0.1%
 
1919.98999 1 < 0.1%
 
1899.98999 1 < 0.1%
 
1889.98999 1 < 0.1%
 
1859.98999 1 < 0.1%
 

Delivery Status
Categorical

Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Late delivery
98972
Advance shipping
41589
Shipping on time
32193
Shipping canceled
 
7754
ValueCountFrequency (%) 
Late delivery 98972 54.8%
 
Advance shipping 41589 23.0%
 
Shipping on time 32193 17.8%
 
Shipping canceled 7754 4.3%
 

Length

Max length17
Mean length14.39806546
Min length13
ValueCountFrequency (%) 
Lowercase_Letter 17 81.0%
 
Uppercase_Letter 3 14.3%
 
Space_Separator 1 4.8%
 
ValueCountFrequency (%) 
Latin 20 95.2%
 
Common 1 4.8%
 
ValueCountFrequency (%) 
ASCII 21 100.0%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
1
98972
0
81536
ValueCountFrequency (%) 
1 98972 54.8%
 
0 81536 45.2%
 

Category Name
Categorical

HIGH CORRELATION
Distinct count50
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Cleats
24551
Men's Footwear
22246
Women's Apparel
21035
Indoor/Outdoor Games
19298
Fishing
17325
Other values (45)
76053
ValueCountFrequency (%) 
Cleats 24551 13.6%
 
Men's Footwear 22246 12.3%
 
Women's Apparel 21035 11.7%
 
Indoor/Outdoor Games 19298 10.7%
 
Fishing 17325 9.6%
 
Water Sports 15540 8.6%
 
Camping & Hiking 13729 7.6%
 
Cardio Equipment 12487 6.9%
 
Shop By Sport 10984 6.1%
 
Electronics 3156 1.7%
 
Other values (40) 20157 11.2%
 

Length

Max length20
Mean length12.70769163
Min length4
ValueCountFrequency (%) 
Lowercase_Letter 24 49.0%
 
Uppercase_Letter 19 38.8%
 
Other_Punctuation 4 8.2%
 
Space_Separator 1 2.0%
 
Dash_Punctuation 1 2.0%
 
ValueCountFrequency (%) 
Latin 43 87.8%
 
Common 6 12.2%
 
ValueCountFrequency (%) 
ASCII 49 100.0%
 

Customer City
Categorical

HIGH CARDINALITY
Distinct count562
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Caguas
66768
Chicago
 
3885
Los Angeles
 
3416
Brooklyn
 
3412
New York
 
1816
Other values (557)
101211
ValueCountFrequency (%) 
Caguas 66768 37.0%
 
Chicago 3885 2.2%
 
Los Angeles 3416 1.9%
 
Brooklyn 3412 1.9%
 
New York 1816 1.0%
 
Philadelphia 1577 0.9%
 
Bronx 1500 0.8%
 
San Diego 1437 0.8%
 
Miami 1314 0.7%
 
Houston 1297 0.7%
 
Other values (552) 94086 52.1%
 

Length

Max length20
Mean length7.708683272
Min length4
ValueCountFrequency (%) 
Lowercase_Letter 26 50.0%
 
Uppercase_Letter 25 48.1%
 
Space_Separator 1 1.9%
 
ValueCountFrequency (%) 
Latin 51 98.1%
 
Common 1 1.9%
 
ValueCountFrequency (%) 
ASCII 52 100.0%
 

Customer Country
Categorical

HIGH CORRELATION
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
EE. UU.
111137
Puerto Rico
69371
ValueCountFrequency (%) 
EE. UU. 111137 61.6%
 
Puerto Rico 69371 38.4%
 

Length

Max length11
Mean length8.537239347
Min length7
ValueCountFrequency (%) 
Lowercase_Letter 7 53.8%
 
Uppercase_Letter 4 30.8%
 
Space_Separator 1 7.7%
 
Other_Punctuation 1 7.7%
 
ValueCountFrequency (%) 
Latin 11 84.6%
 
Common 2 15.4%
 
ValueCountFrequency (%) 
ASCII 13 100.0%
 

Customer Fname
Categorical

HIGH CARDINALITY
Distinct count775
Unique (%)0.4%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Mary
65150
James
 
1835
Robert
 
1759
Michael
 
1680
David
 
1625
Other values (770)
108459
ValueCountFrequency (%) 
Mary 65150 36.1%
 
James 1835 1.0%
 
Robert 1759 1.0%
 
Michael 1680 0.9%
 
David 1625 0.9%
 
John 1446 0.8%
 
William 1365 0.8%
 
Joseph 1117 0.6%
 
Jennifer 1033 0.6%
 
Richard 1032 0.6%
 
Other values (765) 102466 56.8%
 

Length

Max length11
Mean length5.274674807
Min length2
ValueCountFrequency (%) 
Uppercase_Letter 26 50.0%
 
Lowercase_Letter 26 50.0%
 
ValueCountFrequency (%) 
Latin 52 100.0%
 
ValueCountFrequency (%) 
ASCII 52 100.0%
 

Customer Lname
Categorical

HIGH CARDINALITY
Distinct count1109
Unique (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Smith
64104
Johnson
 
989
Brown
 
909
Williams
 
869
Jones
 
859
Other values (1104)
112778
ValueCountFrequency (%) 
Smith 64104 35.5%
 
Johnson 989 0.5%
 
Brown 909 0.5%
 
Williams 869 0.5%
 
Jones 859 0.5%
 
Garcia 724 0.4%
 
Wilson 675 0.4%
 
Taylor 661 0.4%
 
Davis 640 0.4%
 
Moore 599 0.3%
 
Other values (1099) 109479 60.7%
 

Length

Max length12
Mean length5.712395019
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 26 51.0%
 
Uppercase_Letter 25 49.0%
 
ValueCountFrequency (%) 
Latin 51 100.0%
 
ValueCountFrequency (%) 
ASCII 51 100.0%
 

Customer Segment
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Consumer
93501
Corporate
54784
Home Office
32223
ValueCountFrequency (%) 
Consumer 93501 51.8%
 
Corporate 54784 30.3%
 
Home Office 32223 17.9%
 

Length

Max length11
Mean length8.839037605
Min length8
ValueCountFrequency (%) 
Lowercase_Letter 13 76.5%
 
Uppercase_Letter 3 17.6%
 
Space_Separator 1 5.9%
 
ValueCountFrequency (%) 
Latin 16 94.1%
 
Common 1 5.9%
 
ValueCountFrequency (%) 
ASCII 17 100.0%
 

Customer State
Categorical

HIGH CORRELATION
Distinct count44
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
PR
69371
CA
29221
NY
 
11327
TX
 
9102
IL
 
7630
Other values (39)
53857
ValueCountFrequency (%) 
PR 69371 38.4%
 
CA 29221 16.2%
 
NY 11327 6.3%
 
TX 9102 5.0%
 
IL 7630 4.2%
 
FL 5456 3.0%
 
OH 4095 2.3%
 
PA 3824 2.1%
 
MI 3804 2.1%
 
NJ 3191 1.8%
 
Other values (34) 33487 18.6%
 

Length

Max length2
Mean length2
Min length2
ValueCountFrequency (%) 
Uppercase_Letter 24 100.0%
 
ValueCountFrequency (%) 
Latin 24 100.0%
 
ValueCountFrequency (%) 
ASCII 24 100.0%
 

Customer Street
Categorical

HIGH CARDINALITY
Distinct count7456
Unique (%)4.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
9126 Wishing Expressway
 
122
4388 Burning Goose Ridge
 
117
4720 Noble Hills Wynd
 
116
2878 Hazy Wagon Thicket
 
113
398 Emerald Grove
 
109
Other values (7451)
179931
ValueCountFrequency (%) 
9126 Wishing Expressway 122 0.1%
 
4388 Burning Goose Ridge 117 0.1%
 
4720 Noble Hills Wynd 116 0.1%
 
2878 Hazy Wagon Thicket 113 0.1%
 
398 Emerald Grove 109 0.1%
 
3593 Blue Brook Acres 108 0.1%
 
2210 Merry Leaf Row 107 0.1%
 
6289 Rocky Way 107 0.1%
 
2585 Silent Autumn Landing 105 0.1%
 
7694 Velvet Turnabout 103 0.1%
 
Other values (7446) 179401 99.4%
 

Length

Max length33
Mean length19.95735923
Min length12
ValueCountFrequency (%) 
Lowercase_Letter 25 41.0%
 
Uppercase_Letter 24 39.3%
 
Decimal_Number 10 16.4%
 
Space_Separator 1 1.6%
 
Dash_Punctuation 1 1.6%
 
ValueCountFrequency (%) 
Latin 49 80.3%
 
Common 12 19.7%
 
ValueCountFrequency (%) 
ASCII 61 100.0%
 

Customer Zipcode
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count995
Unique (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35920.2467
Minimum603
Maximum99205
Zeros0
Zeros (%)0.0%
Memory size1.4 MiB

Quantile statistics

Minimum603
5-th percentile725
Q1725
median19380
Q378202.5
95-th percentile94538
Maximum99205
Range98602
Interquartile range (IQR)77477.5

Descriptive statistics

Standard deviation37542.21461
Coefficient of variation (CV)1.045154699
Kurtosis-1.451371047
Mean35920.2467
Median Absolute Deviation (MAD)34305.49878
Skewness0.4909268924
Sum6483891891
Variance1409417878
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 603. 607.5 677. 695.5 711.5 ... 98044.5 98161.5 98217. 98308. 99205. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
725 66768 37.0%
 
921 337 0.2%
 
23455 334 0.2%
 
957 297 0.2%
 
79109 292 0.2%
 
33324 283 0.2%
 
80012 280 0.2%
 
33624 261 0.1%
 
92115 256 0.1%
 
97701 254 0.1%
 
Other values (985) 111146 61.6%
 
ValueCountFrequency (%) 
603 50 < 0.1%
 
612 122 0.1%
 
674 169 0.1%
 
680 133 0.1%
 
685 126 0.1%
 
ValueCountFrequency (%) 
99205 43 < 0.1%
 
98632 67 < 0.1%
 
98390 28 < 0.1%
 
98226 47 < 0.1%
 
98208 95 0.1%
 

Department Name
Categorical

HIGH CORRELATION
Distinct count11
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Fan Shop
66861
Apparel
48990
Golf
33220
Footwear
14525
Outdoors
 
9686
Other values (6)
 
7226
ValueCountFrequency (%) 
Fan Shop 66861 37.0%
 
Apparel 48990 27.1%
 
Golf 33220 18.4%
 
Footwear 14525 8.0%
 
Outdoors 9686 5.4%
 
Fitness 2479 1.4%
 
Discs Shop 2025 1.1%
 
Technology 1463 0.8%
 
Pet Shop 492 0.3%
 
Book Shop 405 0.2%
 

Length

Max length18
Mean length7.039665832
Min length4
ValueCountFrequency (%) 
Lowercase_Letter 19 63.3%
 
Uppercase_Letter 10 33.3%
 
Space_Separator 1 3.3%
 
ValueCountFrequency (%) 
Latin 29 96.7%
 
Common 1 3.3%
 
ValueCountFrequency (%) 
ASCII 30 100.0%
 

Latitude
Real number (ℝ)

Distinct count11247
Unique (%)6.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29.71985802
Minimum-33.93755341
Maximum48.78193283
Zeros0
Zeros (%)0.0%
Memory size1.4 MiB

Quantile statistics

Minimum-33.93755341
5-th percentile18.21293068
Q118.26543236
median33.14486313
Q339.27961731
95-th percentile42.39110184
Maximum48.78193283
Range82.71948624
Interquartile range (IQR)21.01418495

Descriptive statistics

Standard deviation9.813737303
Coefficient of variation (CV)0.3302080816
Kurtosis-1.555431167
Mean29.71985802
Median Absolute Deviation (MAD)9.08998316
Skewness-0.09793750906
Sum5364672.132
Variance96.30943985
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-33.93755341 -7.97753143 17.99465561 18.02520657 18.02536583 ... 47.91032028 47.91926957 48.3484974 48.77644539 48.78193283], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
18.2275734 417 0.2%
 
39.49591446 370 0.2%
 
18.22757721 300 0.2%
 
36.91083145 280 0.2%
 
26.0984993 270 0.1%
 
18.38011932 267 0.1%
 
33.04647064 234 0.1%
 
26.21472931 218 0.1%
 
32.75856018 218 0.1%
 
40.64759827 212 0.1%
 
Other values (11237) 177722 98.5%
 
ValueCountFrequency (%) 
-33.93755341 9 < 0.1%
 
17.98249054 38 < 0.1%
 
18.00682068 22 < 0.1%
 
18.01836205 20 < 0.1%
 
18.02520371 17 < 0.1%
 
ValueCountFrequency (%) 
48.78193283 6 < 0.1%
 
48.77095795 41 < 0.1%
 
47.92603684 7 < 0.1%
 
47.91250229 4 < 0.1%
 
47.90813828 20 < 0.1%
 

Longitude
Real number (ℝ)

HIGH CORRELATION
Distinct count4485
Unique (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-84.91444872
Minimum-158.0259857
Maximum115.2630768
Zeros0
Zeros (%)0.0%
Memory size1.4 MiB

Quantile statistics

Minimum-158.0259857
5-th percentile-121.4349442
Q1-98.44631195
median-76.84075928
Q3-66.37058258
95-th percentile-66.18312836
Maximum115.2630768
Range273.2890625
Interquartile range (IQR)32.07572937

Descriptive statistics

Standard deviation21.4322901
Coefficient of variation (CV)-0.252398625
Kurtosis2.181384875
Mean-84.91444872
Median Absolute Deviation (MAD)17.88714999
Skewness-0.4983960889
Sum-15327737.31
Variance459.3430591
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-158.0259857 -158.0131302 -158.00472255 -158.0046539 -157.9979477 ... 47.83176613 79.77704621 83.60233688 115.1564331 115.2630768 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-66.3706131 3821 2.1%
 
-66.37057495 3523 2.0%
 
-66.37059021 3522 2.0%
 
-66.37050629 3465 1.9%
 
-66.37055206 3417 1.9%
 
-66.37052918 3408 1.9%
 
-66.3705368 3377 1.9%
 
-66.37055969 3242 1.8%
 
-66.37060547 3230 1.8%
 
-66.37058258 3155 1.7%
 
Other values (4475) 146348 81.1%
 
ValueCountFrequency (%) 
-158.0259857 73 < 0.1%
 
-158.016037 134 0.1%
 
-158.0102234 18 < 0.1%
 
-158.0047607 7 < 0.1%
 
-158.0046844 43 < 0.1%
 
ValueCountFrequency (%) 
115.2630768 17 < 0.1%
 
115.0497894 17 < 0.1%
 
84.74267578 8 < 0.1%
 
82.46199799 22 < 0.1%
 
77.09209442 32 < 0.1%
 

Market
Categorical

HIGH CORRELATION
Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
LATAM
51594
Europe
50247
Pacific Asia
41254
USCA
25799
Africa
11614
ValueCountFrequency (%) 
LATAM 51594 28.6%
 
Europe 50247 27.8%
 
Pacific Asia 41254 22.9%
 
USCA 25799 14.3%
 
Africa 11614 6.4%
 

Length

Max length12
Mean length6.79958783
Min length4
ValueCountFrequency (%) 
Lowercase_Letter 10 50.0%
 
Uppercase_Letter 9 45.0%
 
Space_Separator 1 5.0%
 
ValueCountFrequency (%) 
Latin 19 95.0%
 
Common 1 5.0%
 
ValueCountFrequency (%) 
ASCII 20 100.0%
 

Order City
Categorical

HIGH CARDINALITY
Distinct count3597
Unique (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Santo Domingo
 
2211
New York City
 
2202
Los Angeles
 
1845
Tegucigalpa
 
1783
Managua
 
1682
Other values (3592)
170785
ValueCountFrequency (%) 
Santo Domingo 2211 1.2%
 
New York City 2202 1.2%
 
Los Angeles 1845 1.0%
 
Tegucigalpa 1783 1.0%
 
Managua 1682 0.9%
 
Mexico City 1484 0.8%
 
Manila 1379 0.8%
 
Philadelphia 1302 0.7%
 
San Francisco 1297 0.7%
 
London 1187 0.7%
 
Other values (3587) 164136 90.9%
 

Length

Max length35
Mean length8.554296762
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 42 53.2%
 
Uppercase_Letter 29 36.7%
 
Other_Punctuation 3 3.8%
 
Control 1 1.3%
 
Open_Punctuation 1 1.3%
 
Close_Punctuation 1 1.3%
 
Space_Separator 1 1.3%
 
Dash_Punctuation 1 1.3%
 
ValueCountFrequency (%) 
Latin 71 89.9%
 
Common 8 10.1%
 
ValueCountFrequency (%) 
ASCII 59 100.0%
 

Order Country
Categorical

HIGH CARDINALITY
Distinct count164
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Estados Unidos
24840
Francia
 
13221
México
 
13172
Alemania
 
9563
Australia
 
8497
Other values (159)
111215
ValueCountFrequency (%) 
Estados Unidos 24840 13.8%
 
Francia 13221 7.3%
 
México 13172 7.3%
 
Alemania 9563 5.3%
 
Australia 8497 4.7%
 
Brasil 7987 4.4%
 
Reino Unido 7301 4.0%
 
China 5757 3.2%
 
Italia 4988 2.8%
 
India 4782 2.6%
 
Other values (154) 80400 44.5%
 

Length

Max length31
Mean length8.772896492
Min length4
ValueCountFrequency (%) 
Lowercase_Letter 32 52.5%
 
Uppercase_Letter 25 41.0%
 
Space_Separator 1 1.6%
 
Close_Punctuation 1 1.6%
 
Dash_Punctuation 1 1.6%
 
Open_Punctuation 1 1.6%
 
ValueCountFrequency (%) 
Latin 57 93.4%
 
Common 4 6.6%
 
ValueCountFrequency (%) 
ASCII 54 100.0%
 
Distinct count65741
Unique (%)36.4%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Minimum2015-01-01 00:00:00
Maximum2018-01-31 23:38:00
Histogram

Order Item Discount
Real number (ℝ≥0)

ZEROS
Distinct count1017
Unique (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.6639984
Minimum0
Maximum500
Zeros10028
Zeros (%)5.6%
Memory size1.4 MiB

Quantile statistics

Minimum0
5-th percentile0
Q15.400000095
median14
Q329.98999977
95-th percentile62.5
Maximum500
Range500
Interquartile range (IQR)24.58999968

Descriptive statistics

Standard deviation21.80075323
Coefficient of variation (CV)1.055011368
Kurtosis25.23396113
Mean20.6639984
Median Absolute Deviation (MAD)15.6809574
Skewness3.040034424
Sum3730017.023
Variance475.2728412
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 5.00000005e-02 1.05000000e-01 1.35000001e-01 2.25000001e-01 ... 2.12500000e+02 3.10000000e+02 3.67500000e+02 3.87500000e+02 5.00000000e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 10028 5.6%
 
6 4589 2.5%
 
12 4067 2.3%
 
4 3647 2.0%
 
8 3626 2.0%
 
10 3424 1.9%
 
36 3268 1.8%
 
30 3230 1.8%
 
20 3123 1.7%
 
9 2964 1.6%
 
Other values (1007) 138542 76.8%
 
ValueCountFrequency (%) 
0 10028 5.6%
 
0.100000001 3 < 0.1%
 
0.109999999 15 < 0.1%
 
0.119999997 29 < 0.1%
 
0.150000006 7 < 0.1%
 
ValueCountFrequency (%) 
500 1 < 0.1%
 
400 1 < 0.1%
 
375 25 < 0.1%
 
360 1 < 0.1%
 
340 1 < 0.1%
 

Order Item Discount Rate
Real number (ℝ≥0)

ZEROS
Distinct count18
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.1016681814
Minimum0
Maximum0.25
Zeros10028
Zeros (%)5.6%
Memory size1.4 MiB

Quantile statistics

Minimum0
5-th percentile0
Q10.039999999
median0.100000001
Q30.159999996
95-th percentile0.25
Maximum0.25
Range0.25
Interquartile range (IQR)0.119999997

Descriptive statistics

Standard deviation0.07041558421
Coefficient of variation (CV)0.6926019846
Kurtosis-0.9012042473
Mean0.1016681814
Median Absolute Deviation (MAD)0.06074105894
Skewness0.3408986005
Sum18351.92009
Variance0.0049583545
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.005 0.065 0.155 0.175 0.19 0.225 0.25 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.129999995 10029 5.6%
 
0.119999997 10029 5.6%
 
0.180000007 10029 5.6%
 
0.050000001 10029 5.6%
 
0.029999999 10029 5.6%
 
0.200000003 10029 5.6%
 
0.150000006 10029 5.6%
 
0.01 10028 5.6%
 
0 10028 5.6%
 
0.039999999 10028 5.6%
 
Other values (8) 80221 44.4%
 
ValueCountFrequency (%) 
0 10028 5.6%
 
0.01 10028 5.6%
 
0.02 10027 5.6%
 
0.029999999 10029 5.6%
 
0.039999999 10028 5.6%
 
ValueCountFrequency (%) 
0.25 10028 5.6%
 
0.200000003 10029 5.6%
 
0.180000007 10029 5.6%
 
0.170000002 10028 5.6%
 
0.159999996 10028 5.6%
 

Order Item Product Price
Real number (ℝ≥0)

Distinct count75
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean141.2221386
Minimum9.989999771
Maximum1999.98999
Zeros0
Zeros (%)0.0%
Memory size1.4 MiB

Quantile statistics

Minimum9.989999771
5-th percentile31.98999977
Q150
median59.99000168
Q3199.9900055
95-th percentile399.980011
Maximum1999.98999
Range1989.99999
Interquartile range (IQR)149.9900055

Descriptive statistics

Standard deviation139.7269598
Coefficient of variation (CV)0.989412575
Kurtosis23.31915976
Mean141.2221386
Median Absolute Deviation (MAD)102.8044493
Skewness3.191550035
Sum25491725.79
Variance19523.62329
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 9.98999977 11.41499996 15.48999977 16.98999977 18.98999977 ... 566.28500365 799.9899902 1249.9949951 1749.994995 1999.98999 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
59.99000168 24820 13.8%
 
129.9900055 22372 12.4%
 
50 21035 11.7%
 
49.97999954 19298 10.7%
 
399.980011 17325 9.6%
 
199.9900055 15622 8.7%
 
299.980011 13729 7.6%
 
99.98999786 12433 6.9%
 
39.99000168 11201 6.2%
 
24.98999977 2339 1.3%
 
Other values (65) 20334 11.3%
 
ValueCountFrequency (%) 
9.989999771 285 0.2%
 
11.28999996 271 0.2%
 
11.53999996 529 0.3%
 
14.98999977 593 0.3%
 
15.98999977 602 0.3%
 
ValueCountFrequency (%) 
1999.98999 15 < 0.1%
 
1500 442 0.2%
 
999.9899902 10 < 0.1%
 
599.9899902 21 < 0.1%
 
532.5800171 484 0.3%
 

Order Item Profit Ratio
Real number (ℝ)

Distinct count162
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.1206388082
Minimum-2.75
Maximum0.5
Zeros1177
Zeros (%)0.7%
Memory size1.4 MiB

Quantile statistics

Minimum-2.75
5-th percentile-0.769999981
Q10.079999998
median0.270000011
Q30.360000014
95-th percentile0.479999989
Maximum0.5
Range3.25
Interquartile range (IQR)0.280000016

Descriptive statistics

Standard deviation0.4668059291
Coefficient of variation (CV)3.869450768
Kurtosis10.156661
Mean0.1206388082
Median Absolute Deviation (MAD)0.2941284219
Skewness-2.89347205
Sum21776.26999
Variance0.2179077754
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-2.75 -2.72500002 -2.67500007 -2.625 -2.47500002 ... 0.465 0.47499999 0.485 0.495 0.5 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.479999989 9197 5.1%
 
0.349999994 7996 4.4%
 
0.25999999 6577 3.6%
 
0.340000004 6506 3.6%
 
0.469999999 6378 3.5%
 
0.360000014 6107 3.4%
 
0.330000013 5789 3.2%
 
0.49000001 5686 3.1%
 
0.289999992 5478 3.0%
 
0.280000001 5402 3.0%
 
Other values (152) 115392 63.9%
 
ValueCountFrequency (%) 
-2.75 72 < 0.1%
 
-2.700000048 252 0.1%
 
-2.650000095 90 < 0.1%
 
-2.599999905 181 0.1%
 
-2.549999952 234 0.1%
 
ValueCountFrequency (%) 
0.5 2529 1.4%
 
0.49000001 5686 3.1%
 
0.479999989 9197 5.1%
 
0.469999999 6378 3.5%
 
0.460000008 4822 2.7%
 

Order Item Quantity
Real number (ℝ≥0)

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.127706251
Minimum1
Maximum5
Zeros0
Zeros (%)0.0%
Memory size1.4 MiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q33
95-th percentile5
Maximum5
Range4
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.453469109
Coefficient of variation (CV)0.6831154951
Kurtosis-0.7538622094
Mean2.127706251
Median Absolute Deviation (MAD)1.267267703
Skewness0.8801600832
Sum384068
Variance2.112572451
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1. 1.5 4.5 5. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 99123 54.9%
 
5 20385 11.3%
 
3 20350 11.3%
 
4 20335 11.3%
 
2 20315 11.3%
 
ValueCountFrequency (%) 
1 99123 54.9%
 
2 20315 11.3%
 
3 20350 11.3%
 
4 20335 11.3%
 
5 20385 11.3%
 
ValueCountFrequency (%) 
5 20385 11.3%
 
4 20335 11.3%
 
3 20350 11.3%
 
2 20315 11.3%
 
1 99123 54.9%
 

Sales
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count193
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean203.7654958
Minimum9.989999771
Maximum1999.98999
Zeros0
Zeros (%)0.0%
Memory size1.4 MiB

Quantile statistics

Minimum9.989999771
5-th percentile49.97999954
Q1119.9800034
median199.9199982
Q3299.9500122
95-th percentile399.980011
Maximum1999.98999
Range1989.99999
Interquartile range (IQR)179.9700088

Descriptive statistics

Standard deviation132.2707879
Coefficient of variation (CV)0.6491324123
Kurtosis23.94036104
Mean203.7654958
Median Absolute Deviation (MAD)95.93699883
Skewness2.884585489
Sum36781302.12
Variance17495.56132
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 9.98999977 10.63999987 13.26499987 16.98999977 19.98499966 ... 566.28500365 799.9899902 1249.9949951 1749.994995 1999.98999 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
129.9900055 22372 12.4%
 
399.980011 17325 9.6%
 
199.9900055 15622 8.7%
 
299.980011 13729 7.6%
 
179.9700012 5016 2.8%
 
299.9500122 4988 2.8%
 
119.9800034 4968 2.8%
 
239.9600067 4955 2.7%
 
59.99000168 4893 2.7%
 
50 4432 2.5%
 
Other values (183) 82208 45.5%
 
ValueCountFrequency (%) 
9.989999771 56 < 0.1%
 
11.28999996 271 0.2%
 
11.53999996 529 0.3%
 
14.98999977 124 0.1%
 
15.98999977 118 0.1%
 
ValueCountFrequency (%) 
1999.98999 15 < 0.1%
 
1500 442 0.2%
 
999.9899902 10 < 0.1%
 
599.9899902 21 < 0.1%
 
532.5800171 484 0.3%
 

Order Region
Categorical

HIGH CORRELATION
Distinct count23
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Central America
28341
Western Europe
27107
South America
 
14935
Oceania
 
10148
Northern Europe
 
9790
Other values (18)
90187
ValueCountFrequency (%) 
Central America 28341 15.7%
 
Western Europe 27107 15.0%
 
South America 14935 8.3%
 
Oceania 10148 5.6%
 
Northern Europe 9790 5.4%
 
Southeast Asia 9535 5.3%
 
Southern Europe 9430 5.2%
 
Caribbean 8318 4.6%
 
West of USA 7993 4.4%
 
South Asia 7730 4.3%
 
Other values (13) 47181 26.1%
 

Length

Max length15
Mean length12.63423782
Min length6
ValueCountFrequency (%) 
Lowercase_Letter 17 65.4%
 
Uppercase_Letter 8 30.8%
 
Space_Separator 1 3.8%
 
ValueCountFrequency (%) 
Latin 25 96.2%
 
Common 1 3.8%
 
ValueCountFrequency (%) 
ASCII 26 100.0%
 

Order State
Categorical

HIGH CARDINALITY
Distinct count1089
Unique (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Inglaterra
 
6721
California
 
4966
Isla de Francia
 
4580
Renania del Norte-Westfalia
 
3302
San Salvador
 
3055
Other values (1084)
157884
ValueCountFrequency (%) 
Inglaterra 6721 3.7%
 
California 4966 2.8%
 
Isla de Francia 4580 2.5%
 
Renania del Norte-Westfalia 3302 1.8%
 
San Salvador 3055 1.7%
 
Nueva York 2753 1.5%
 
Distrito Federal 2559 1.4%
 
Texas 2446 1.4%
 
Nueva Gales del Sur 2370 1.3%
 
Santo Domingo 2211 1.2%
 
Other values (1079) 145545 80.6%
 

Length

Max length36
Mean length10.87242117
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 45 54.2%
 
Uppercase_Letter 30 36.1%
 
Control 2 2.4%
 
Other_Punctuation 2 2.4%
 
Open_Punctuation 1 1.2%
 
Close_Punctuation 1 1.2%
 
Space_Separator 1 1.2%
 
Dash_Punctuation 1 1.2%
 
ValueCountFrequency (%) 
Latin 75 90.4%
 
Common 8 9.6%
 
ValueCountFrequency (%) 
ASCII 58 100.0%
 

Order Status
Categorical

HIGH CORRELATION
Distinct count9
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
COMPLETE
59487
PENDING_PAYMENT
39829
PROCESSING
21902
PENDING
20224
CLOSED
19616
Other values (4)
19450
ValueCountFrequency (%) 
COMPLETE 59487 33.0%
 
PENDING_PAYMENT 39829 22.1%
 
PROCESSING 21902 12.1%
 
PENDING 20224 11.2%
 
CLOSED 19616 10.9%
 
ON_HOLD 9803 5.4%
 
SUSPECTED_FRAUD 4062 2.3%
 
CANCELED 3692 2.0%
 
PAYMENT_REVIEW 1893 1.0%
 

Length

Max length15
Mean length9.623972345
Min length6
ValueCountFrequency (%) 
Uppercase_Letter 20 95.2%
 
Connector_Punctuation 1 4.8%
 
ValueCountFrequency (%) 
Latin 20 95.2%
 
Common 1 4.8%
 
ValueCountFrequency (%) 
ASCII 21 100.0%
 
Distinct count118
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck
24515
http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat
22246
http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo
21035
http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest
19298
http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe
17325
Other values (113)
76089
ValueCountFrequency (%) 
http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck 24515 13.6%
 
http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat 22246 12.3%
 
http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo 21035 11.7%
 
http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest 19298 10.7%
 
http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe 17325 9.6%
 
http://images.acmesports.sports/Pelican+Sunstream+100+Kayak 15500 8.6%
 
http://images.acmesports.sports/Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014 13729 7.6%
 
http://images.acmesports.sports/Nike+Men%27s+Free+5.0%2B+Running+Shoe 12169 6.7%
 
http://images.acmesports.sports/Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe 10617 5.9%
 
http://images.acmesports.sports/Fighting+video+games 837 0.5%
 
Other values (108) 23237 12.9%
 
ValueCountFrequency (%) 
http 180508 100.0%
 
ValueCountFrequency (%) 
images.acmesports.sports 180508 100.0%
 
ValueCountFrequency (%) 
/Perfect+Fitness+Perfect+Rip+Deck 24515 13.6%
 
/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat 22246 12.3%
 
/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo 21035 11.7%
 
/O%27Brien+Men%27s+Neoprene+Life+Vest 19298 10.7%
 
/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe 17325 9.6%
 
/Pelican+Sunstream+100+Kayak 15500 8.6%
 
/Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014 13729 7.6%
 
/Nike+Men%27s+Free+5.0%2B+Running+Shoe 12169 6.7%
 
/Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe 10617 5.9%
 
/Fighting+video+games 837 0.5%
 
Other values (108) 23237 12.9%
 
ValueCountFrequency (%) 
180508 100.0%
 
ValueCountFrequency (%) 
180508 100.0%
 

Product Name
Categorical

HIGH CARDINALITY
Distinct count118
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Perfect Fitness Perfect Rip Deck
24515
Nike Men's CJ Elite 2 TD Football Cleat
22246
Nike Men's Dri-FIT Victory Golf Polo
21035
O'Brien Men's Neoprene Life Vest
19298
Field & Stream Sportsman 16 Gun Fire Safe
17325
Other values (113)
76089
ValueCountFrequency (%) 
Perfect Fitness Perfect Rip Deck 24515 13.6%
 
Nike Men's CJ Elite 2 TD Football Cleat 22246 12.3%
 
Nike Men's Dri-FIT Victory Golf Polo 21035 11.7%
 
O'Brien Men's Neoprene Life Vest 19298 10.7%
 
Field & Stream Sportsman 16 Gun Fire Safe 17325 9.6%
 
Pelican Sunstream 100 Kayak 15500 8.6%
 
Diamondback Women's Serene Classic Comfort Bi 13729 7.6%
 
Nike Men's Free 5.0+ Running Shoe 12169 6.7%
 
Under Armour Girls' Toddler Spine Surge Runni 10617 5.9%
 
Fighting video games 837 0.5%
 
Other values (108) 23237 12.9%
 

Length

Max length45
Mean length35.12096971
Min length5
ValueCountFrequency (%) 
Uppercase_Letter 25 37.9%
 
Lowercase_Letter 24 36.4%
 
Decimal_Number 10 15.2%
 
Other_Punctuation 4 6.1%
 
Math_Symbol 1 1.5%
 
Space_Separator 1 1.5%
 
Dash_Punctuation 1 1.5%
 
ValueCountFrequency (%) 
Latin 49 74.2%
 
Common 17 25.8%
 
ValueCountFrequency (%) 
ASCII 66 100.0%
 

Product Status
Boolean

CONSTANT
REJECTED
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
0
180508
ValueCountFrequency (%) 
0 180508 100.0%
 
Distinct count63692
Unique (%)35.3%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Minimum2015-01-03 00:00:00
Maximum2018-02-06 22:14:00
Histogram

Shipping Mode
Categorical

HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.4 MiB
Standard Class
107745
Second Class
35214
First Class
27812
Same Day
 
9737
ValueCountFrequency (%) 
Standard Class 107745 59.7%
 
Second Class 35214 19.5%
 
First Class 27812 15.4%
 
Same Day 9737 5.4%
 

Length

Max length14
Mean length12.8239524
Min length8
ValueCountFrequency (%) 
Lowercase_Letter 13 72.2%
 
Uppercase_Letter 4 22.2%
 
Space_Separator 1 5.6%
 
ValueCountFrequency (%) 
Latin 17 94.4%
 
Common 1 5.6%
 
ValueCountFrequency (%) 
ASCII 18 100.0%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

df_indexTypeDays for shipping (real)Days for shipment (scheduled)Benefit per orderSales per customerDelivery StatusLate_delivery_riskCategory NameCustomer CityCustomer CountryCustomer FnameCustomer LnameCustomer SegmentCustomer StateCustomer StreetCustomer ZipcodeDepartment NameLatitudeLongitudeMarketOrder CityOrder Countryorder date (DateOrders)Order Item DiscountOrder Item Discount RateOrder Item Product PriceOrder Item Profit RatioOrder Item QuantitySalesOrder RegionOrder StateOrder StatusProduct ImageProduct NameProduct Statusshipping date (DateOrders)Shipping Mode
00DEBIT3491.250000314.640015Advance shipping0Sporting GoodsCaguasPuerto RicoCallyHollowayConsumerPR5365 Noble Nectar Island725Fitness18.251453-66.037056Pacific AsiaBekasiIndonesia2018-01-31 22:56:0013.1100000.04327.750.291327.75Southeast AsiaJava OccidentalCOMPLETEhttp://images.acmesports.sports/Smart+watchSmart watch02018-02-03 22:56:00Standard Class
11TRANSFER54-249.089996311.359985Late delivery1Sporting GoodsCaguasPuerto RicoIreneLunaConsumerPR2679 Rustic Loop725Fitness18.279451-66.037064Pacific AsiaBikanerIndia2018-01-13 12:27:0016.3899990.05327.75-0.801327.75South AsiaRajastánPENDINGhttp://images.acmesports.sports/Smart+watchSmart watch02018-01-18 12:27:00Standard Class
22CASH44-247.779999309.720001Shipping on time0Sporting GoodsSan JoseEE. UU.GillianMaldonadoConsumerCA8510 Round Bear Gate95125Fitness37.292233-121.881279Pacific AsiaBikanerIndia2018-01-13 12:06:0018.0300010.06327.75-0.801327.75South AsiaRajastánCLOSEDhttp://images.acmesports.sports/Smart+watchSmart watch02018-01-17 12:06:00Standard Class
33DEBIT3422.860001304.809998Advance shipping0Sporting GoodsLos AngelesEE. UU.TanaTateHome OfficeCA3200 Amber Bend90027Fitness34.125946-118.291016Pacific AsiaTownsvilleAustralia2018-01-13 11:45:0022.9400010.07327.750.081327.75OceaniaQueenslandCOMPLETEhttp://images.acmesports.sports/Smart+watchSmart watch02018-01-16 11:45:00Standard Class
44PAYMENT24134.210007298.250000Advance shipping0Sporting GoodsCaguasPuerto RicoOrliHendricksCorporatePR8671 Iron Anchor Corners725Fitness18.253769-66.037048Pacific AsiaTownsvilleAustralia2018-01-13 11:24:0029.5000000.09327.750.451327.75OceaniaQueenslandPENDING_PAYMENThttp://images.acmesports.sports/Smart+watchSmart watch02018-01-15 11:24:00Standard Class
55TRANSFER6418.580000294.980011Shipping canceled0Sporting GoodsTonawandaEE. UU.KimberlyFlowersConsumerNY2122 Hazy Corner14150Fitness43.013969-78.879066Pacific AsiaToowoombaAustralia2018-01-13 11:03:0032.7799990.10327.750.061327.75OceaniaQueenslandCANCELEDhttp://images.acmesports.sports/Smart+watchSmart watch02018-01-19 11:03:00Standard Class
66DEBIT2195.180000288.420013Late delivery1Sporting GoodsCaguasPuerto RicoConstanceTerrellHome OfficePR1879 Green Pine Bank725Fitness18.242538-66.037056Pacific AsiaGuangzhouChina2018-01-13 10:42:0039.3300020.12327.750.331327.75Eastern AsiaGuangdongCOMPLETEhttp://images.acmesports.sports/Smart+watchSmart watch02018-01-15 10:42:00First Class
77TRANSFER2168.430000285.140015Late delivery1Sporting GoodsMiamiEE. UU.EricaStevensCorporateFL7595 Cotton Log Row33162Fitness25.928869-80.162872Pacific AsiaGuangzhouChina2018-01-13 10:21:0042.6100010.13327.750.241327.75Eastern AsiaGuangdongPROCESSINGhttp://images.acmesports.sports/Smart+watchSmart watch02018-01-15 10:21:00First Class
88CASH32133.720001278.589996Late delivery1Sporting GoodsCaguasPuerto RicoNicholeOlsenCorporatePR2051 Dusty Route725Fitness18.233223-66.037056Pacific AsiaGuangzhouChina2018-01-13 10:00:0049.1600000.15327.750.481327.75Eastern AsiaGuangdongCLOSEDhttp://images.acmesports.sports/Smart+watchSmart watch02018-01-16 10:00:00Second Class
99CASH21132.149994275.309998Late delivery1Sporting GoodsSan RamonEE. UU.OprahDelacruzCorporateCA9139 Blue Blossom Court94583Fitness37.773991-121.966629Pacific AsiaGuangzhouChina2018-01-13 09:39:0052.4399990.16327.750.481327.75Eastern AsiaGuangdongCLOSEDhttp://images.acmesports.sports/Smart+watchSmart watch02018-01-15 09:39:00First Class

Last rows

df_indexTypeDays for shipping (real)Days for shipment (scheduled)Benefit per orderSales per customerDelivery StatusLate_delivery_riskCategory NameCustomer CityCustomer CountryCustomer FnameCustomer LnameCustomer SegmentCustomer StateCustomer StreetCustomer ZipcodeDepartment NameLatitudeLongitudeMarketOrder CityOrder Countryorder date (DateOrders)Order Item DiscountOrder Item Discount RateOrder Item Product PriceOrder Item Profit RatioOrder Item QuantitySalesOrder RegionOrder StateOrder StatusProduct ImageProduct NameProduct Statusshipping date (DateOrders)Shipping Mode
180498180509PAYMENT340.000000335.980011Advance shipping0FishingCaguasPuerto RicoMelissaWilcoxCorporatePR9453 High Concession725Fan Shop18.359095-66.079956Pacific AsiaGuangshuiChina2016-01-16 06:49:0064.00.16399.9800110.001399.980011Eastern AsiaHubeiPENDING_PAYMENThttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-19 06:49:00Standard Class
180499180510PAYMENT34165.990005331.980011Advance shipping0FishingCaguasPuerto RicoMelissaWilcoxCorporatePR9453 High Concession725Fan Shop18.359095-66.079956Pacific AsiaGuangshuiChina2016-01-16 06:49:0068.00.17399.9800110.501399.980011Eastern AsiaHubeiPENDING_PAYMENThttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-19 06:49:00Standard Class
180500180511DEBIT22157.429993327.980011Shipping on time0FishingChula VistaEE. UU.OliviaSmithConsumerCA3760 Stony Promenade91911Fan Shop32.611141-117.073662Pacific AsiaChengduChina2016-01-16 06:28:0072.00.18399.9800110.481399.980011Eastern AsiaSichuanON_HOLDhttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-18 06:28:00Second Class
180501180512DEBIT6486.400002319.980011Late delivery1FishingCaguasPuerto RicoMaryMaddenHome OfficePR9918 Lazy Cape725Fan Shop18.245256-66.370621Pacific AsiaChengduChina2016-01-16 06:07:0080.00.20399.9800110.271399.980011Eastern AsiaSichuanCOMPLETEhttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-22 06:07:00Standard Class
180502180513PAYMENT34119.989998299.989990Advance shipping0FishingLancasterEE. UU.MarySmithHome OfficeOH8600 Red Goose Abbey43130Fan Shop39.715977-82.599297Pacific AsiaShangháiChina2016-01-16 05:04:00100.00.25399.9800110.401399.980011Eastern AsiaShangháiPENDING_PAYMENThttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-19 05:04:00Standard Class
180503180514CASH4440.000000399.980011Shipping on time0FishingBrooklynEE. UU.MariaPetersonHome OfficeNY1322 Broad Glade11207Fan Shop40.640930-73.942711Pacific AsiaShangháiChina2016-01-16 03:40:000.00.00399.9800110.101399.980011Eastern AsiaShangháiCLOSEDhttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-20 03:40:00Standard Class
180504180515DEBIT32-613.770019395.980011Late delivery1FishingBakersfieldEE. UU.RonaldClarkCorporateCA7330 Broad Apple Moor93304Fan Shop35.362545-119.018700Pacific AsiaHirakataJapón2016-01-16 01:34:004.00.01399.980011-1.551399.980011Eastern AsiaOsakaCOMPLETEhttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-19 01:34:00Second Class
180505180516TRANSFER54141.110001391.980011Late delivery1FishingBristolEE. UU.JohnSmithCorporateCT97 Burning Landing6010Fan Shop41.629959-72.967155Pacific AsiaAdelaideAustralia2016-01-15 21:00:008.00.02399.9800110.361399.980011OceaniaAustralia del SurPENDINGhttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-20 21:00:00Standard Class
180506180517PAYMENT34186.229996387.980011Advance shipping0FishingCaguasPuerto RicoMarySmithConsumerPR2585 Silent Autumn Landing725Fan Shop18.213350-66.370575Pacific AsiaAdelaideAustralia2016-01-15 20:18:0012.00.03399.9800110.481399.980011OceaniaAustralia del SurPENDING_PAYMENThttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-18 20:18:00Standard Class
180507180518PAYMENT44168.949997383.980011Shipping on time0FishingCaguasPuerto RicoAndreaOrtegaConsumerPR697 Little Meadow725Fan Shop18.290380-66.370613Pacific AsiaNagercoilIndia2016-01-15 18:54:0016.00.04399.9800110.441399.980011South AsiaTamil NaduPENDING_PAYMENThttp://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+SafeField & Stream Sportsman 16 Gun Fire Safe02016-01-19 18:54:00Standard Class